package com.credithc.customers.manager.mapper;

import com.credithc.customers.manager.po.*;
import com.credithc.customers.manager.ro.HomeRo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @author zhukai
 * @date 2018/12/13 14:19
 */
@Mapper
@Repository
public interface EChartsMapper {

    List<CustomerStatsSourcePo> statsCustomerCount(@Param("ro")HomeRo ro);

    List<CustomerStatsSourcePo> statsCustomerSum();


    List<CustomerModifyPo> statsCustomerModifyCount(@Param("date") String date);

    List<CustomerModifyPo> statsContactCount(@Param("ro")HomeRo ro);

    List<CustomerModifyPo> statsIdCount(@Param("ro")HomeRo ro);

    List<CustomerModifyPiePo> statsContactModifyCountBySystem();

    List<CustomerModifyPiePo> statsIdModifyCountBySystem();

    List<ExceptionStatsPo> statsExceptionCount();

    List<CustomerProductPiePo> statsCustomerProduct(@Param("customerNo")String customerNo,@Param("startTime") String startTime,@Param("endTime") String endTime,@Param("statsPre") String statsPre);

}
